home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
global_id.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
966b
|
24 lines
/* RCSVER $Id: global_id.sql,v 1.2 1999-02-24 12:52:51-06 randy CURRENT $ */
/* *************************************************************************
* Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
*
* Name: global_id.sql
* Date: 12/28/1998
* memo: Randy Wood
* Description: Create the global_id table. This table contains a list
* of all equipment in the system. Each piece of equipment
* has a unique ID which is used by the software as a
* cross-reference. This is not to be confused by the use of
* any user-defined IDs which are used only for display
* purposes.
* Changes:
************************************************************************* */
CREATE TABLE global_id
(
glid NUMBER(38), /* Internal sq ID of this piece */
equip_type NUMBER(38) /* Type of equipment */
CONSTRAINT ref_equiptype REFERENCES equiptype(equip_type)
ON DELETE CASCADE,
CONSTRAINT pk_globalid PRIMARY KEY (glid)
);